home *** CD-ROM | disk | FTP | other *** search
/ Personal Computer World 2005 October / PCWOCT05.iso / Software / FromTheMag / XAMPP 1.4.14 / xampp-win32-1.4.14-installer.exe / xampp / phpMyAdmin / libraries / information_schema_relations.lib.php < prev    next >
Encoding:
PHP Script  |  2005-03-27  |  4.2 KB  |  130 lines
  1. <?php
  2. /* $Id: information_schema_relations.lib.php,v 2.0 2005/03/27 23:23:39 rabus Exp $ */
  3. // vim: expandtab sw=4 ts=4 sts=4:
  4.  
  5. $GLOBALS['information_schema_relations'] = array(
  6.     'CHARACTER_SETS' => array(
  7.         'DEFAULT_COLLATE_NAME' => array(
  8.             'foreign_db'    => 'information_schema',
  9.             'foreign_table' => 'COLLATIONS',
  10.             'foreign_field' => 'COLLATION_NAME'
  11.         )
  12.     ),
  13.     'COLLATIONS' => array(
  14.         'CHARACTER_SET_NAME' => array(
  15.             'foreign_db'    => 'information_schema',
  16.             'foreign_table' => 'CHARACTER_SETS',
  17.             'foreign_field' => 'CHARACTER_SET_NAME'
  18.         )
  19.     ),
  20.     'COLLATION_CHARACTER_SET_APPLICABILITY' => array(
  21.         'CHARACTER_SET_NAME' => array(
  22.             'foreign_db'    => 'information_schema',
  23.             'foreign_table' => 'CHARACTER_SETS',
  24.             'foreign_field' => 'CHARACTER_SET_NAME'
  25.         ),
  26.         'COLLATION_NAME' => array(
  27.             'foreign_db'    => 'information_schema',
  28.             'foreign_table' => 'COLLATIONS',
  29.             'foreign_field' => 'COLLATION_NAME'
  30.         )
  31.     ),
  32.     'COLUMNS' => array(
  33.         'TABLE_SCHEMA' => array(
  34.             'foreign_db'    => 'information_schema',
  35.             'foreign_table' => 'SCHEMATA',
  36.             'foreign_field' => 'SCHEMA_NAME'
  37.         ),
  38.         'CHARACTER_SET_NAME' => array(
  39.             'foreign_db'    => 'information_schema',
  40.             'foreign_table' => 'CHARACTER_SETS',
  41.             'foreign_field' => 'CHARACTER_SET_NAME'
  42.         ),
  43.         'COLLATION_NAME' => array(
  44.             'foreign_db'    => 'information_schema',
  45.             'foreign_table' => 'COLLATIONS',
  46.             'foreign_field' => 'COLLATION_NAME'
  47.         )
  48.     ),
  49.     'COLUMN_PRIVILEGES' => array(
  50.         'TABLE_SCHEMA' => array(
  51.             'foreign_db'    => 'information_schema',
  52.             'foreign_table' => 'SCHEMATA',
  53.             'foreign_field' => 'SCHEMA_NAME'
  54.         )
  55.     ),
  56.     'KEY_COLUMN_USAGE' => array(
  57.         'CONSTRAINT_SCHEMA' => array(
  58.             'foreign_db'    => 'information_schema',
  59.             'foreign_table' => 'SCHEMATA',
  60.             'foreign_field' => 'SCHEMA_NAME'
  61.         ),
  62.         'TABLE_SCHEMA' => array(
  63.             'foreign_db'    => 'information_schema',
  64.             'foreign_table' => 'SCHEMATA',
  65.             'foreign_field' => 'SCHEMA_NAME'
  66.         )
  67.     ),
  68.     'ROUTINES' => array(
  69.         'ROUTINE_SCHEMA' => array(
  70.             'foreign_db'    => 'information_schema',
  71.             'foreign_table' => 'SCHEMATA',
  72.             'foreign_field' => 'SCHEMA_NAME'
  73.         )
  74.     ),
  75.     'SCHEMATA' => array(
  76.         'DEFAULT_CHARACTER_SET_NAME' => array(
  77.             'foreign_db'    => 'information_schema',
  78.             'foreign_table' => 'CHARACTER_SETS',
  79.             'foreign_field' => 'CHARACTER_SET_NAME'
  80.         )
  81.     ),
  82.     'SCHEMA_PRIVILEGES' => array(
  83.         'TABLE_SCHEMA' => array(
  84.             'foreign_db'    => 'information_schema',
  85.             'foreign_table' => 'SCHEMATA',
  86.             'foreign_field' => 'SCHEMA_NAME'
  87.         )
  88.     ),
  89.     'TABLES' => array(
  90.         'TABLE_SCHEMA' => array(
  91.             'foreign_db'    => 'information_schema',
  92.             'foreign_table' => 'SCHEMATA',
  93.             'foreign_field' => 'SCHEMA_NAME'
  94.         ),
  95.         'TABLE_COLLATION' => array(
  96.             'foreign_db'    => 'information_schema',
  97.             'foreign_table' => 'COLLATIONS',
  98.             'foreign_field' => 'COLLATION_NAME'
  99.         )
  100.     ),
  101.     'TABLE_CONSTRAINTS' => array(
  102.         'CONSTRAINT_SCHEMA' => array(
  103.             'foreign_db'    => 'information_schema',
  104.             'foreign_table' => 'SCHEMATA',
  105.             'foreign_field' => 'SCHEMA_NAME'
  106.         ),
  107.         'TABLE_SCHEMA' => array(
  108.             'foreign_db'    => 'information_schema',
  109.             'foreign_table' => 'SCHEMATA',
  110.             'foreign_field' => 'SCHEMA_NAME'
  111.         )
  112.     ),
  113.     'TABLE_PRIVILEGES' => array(
  114.         'TABLE_SCHEMA' => array(
  115.             'foreign_db'    => 'information_schema',
  116.             'foreign_table' => 'SCHEMATA',
  117.             'foreign_field' => 'SCHEMA_NAME'
  118.         )
  119.     ),
  120.     'VIEWS' => array(
  121.         'TABLE_SCHEMA' => array(
  122.             'foreign_db'    => 'information_schema',
  123.             'foreign_table' => 'SCHEMATA',
  124.             'foreign_field' => 'SCHEMA_NAME'
  125.         )
  126.     )
  127. );
  128.  
  129. ?>
  130.